Dataset statistics
| Number of variables | 15 |
|---|---|
| Number of observations | 342 |
| Missing cells | 1190 |
| Missing cells (%) | 23.2% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 40.6 KiB |
| Average record size in memory | 121.6 B |
Variable types
| DateTime | 1 |
|---|---|
| Categorical | 1 |
| Numeric | 13 |
PTL_total is highly overall correlated with PTL_MDU (Business Days Mean) and 12 other fields | High correlation |
PTL_MDU (Business Days Mean) is highly overall correlated with PTL_total and 12 other fields | High correlation |
PTL_MSD (Saturdays Mean) is highly overall correlated with PTL_total and 12 other fields | High correlation |
PTL_MDO (Sundays Mean) is highly overall correlated with PTL_total and 12 other fields | High correlation |
PTL_MAX (Daily Max) is highly overall correlated with PTL_total and 12 other fields | High correlation |
stations is highly overall correlated with PTL_total and 12 other fields | High correlation |
total_dpea is highly overall correlated with PTL_total and 12 other fields | High correlation |
interval is highly overall correlated with PTL_total and 12 other fields | High correlation |
PEL_total is highly overall correlated with PTL_total and 11 other fields | High correlation |
PEL_business_day_mean is highly overall correlated with PTL_total and 12 other fields | High correlation |
PEL_saturday_mean is highly overall correlated with PTL_total and 12 other fields | High correlation |
PEL_sunday_mean is highly overall correlated with PTL_total and 12 other fields | High correlation |
PEL_max is highly overall correlated with PTL_total and 12 other fields | High correlation |
line is highly overall correlated with PTL_total and 11 other fields | High correlation |
PTL_MSD (Saturdays Mean) has 5 (1.5%) missing values | Missing |
stations has 174 (50.9%) missing values | Missing |
total_dpea has 174 (50.9%) missing values | Missing |
interval has 230 (67.3%) missing values | Missing |
PEL_total has 119 (34.8%) missing values | Missing |
PEL_business_day_mean has 119 (34.8%) missing values | Missing |
PEL_saturday_mean has 119 (34.8%) missing values | Missing |
PEL_sunday_mean has 119 (34.8%) missing values | Missing |
PEL_max has 119 (34.8%) missing values | Missing |
line is uniformly distributed | Uniform |
Reproduction
| Analysis started | 2023-06-10 23:54:07.153865 |
|---|---|
| Analysis finished | 2023-06-10 23:54:24.232550 |
| Duration | 17.08 seconds |
| Software version | ydata-profiling vv4.2.0 |
| Download configuration | config.json |
date
Date
| Distinct | 57 |
|---|---|
| Distinct (%) | 16.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.3 KiB |
| Minimum | 2018-08-01 00:00:00 |
|---|---|
| Maximum | 2023-04-01 00:00:00 |
Histogram with fixed size bins (bins=50)
line
Categorical
HIGH CORRELATION UNIFORM
| Distinct | 6 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.2 KiB |
| 1 | |
|---|---|
| 15 | |
| 2 | |
| 3 | |
| 4 |
Length
| Max length | 2 |
|---|---|
| Median length | 1 |
| Mean length | 1.1666667 |
| Min length | 1 |
Characters and Unicode
| Total characters | 399 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 3 |
|---|---|
| 2nd row | 1 |
| 3rd row | 15 |
| 4th row | 2 |
| 5th row | 5 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 57 | |
| 15 | 57 | |
| 2 | 57 | |
| 3 | 57 | |
| 4 | 57 | |
| 5 | 57 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 57 | |
| 15 | 57 | |
| 2 | 57 | |
| 3 | 57 | |
| 4 | 57 | |
| 5 | 57 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 114 | |
| 5 | 114 | |
| 2 | 57 | |
| 3 | 57 | |
| 4 | 57 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 399 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 114 | |
| 5 | 114 | |
| 2 | 57 | |
| 3 | 57 | |
| 4 | 57 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 399 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 114 | |
| 5 | 114 | |
| 2 | 57 | |
| 3 | 57 | |
| 4 | 57 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 399 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 114 | |
| 5 | 114 | |
| 2 | 57 | |
| 3 | 57 | |
| 4 | 57 |
PTL_total
Real number (ℝ)
| Distinct | 334 |
|---|---|
| Distinct (%) | 98.5% |
| Missing | 3 |
| Missing (%) | 0.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15117870 |
| Minimum | 398000 |
|---|---|
| Maximum | 39719000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.3 KiB |
Quantile statistics
| Minimum | 398000 |
|---|---|
| 5-th percentile | 1574600 |
| Q1 | 8197000 |
| median | 13941000 |
| Q3 | 19975500 |
| 95-th percentile | 35373900 |
| Maximum | 39719000 |
| Range | 39321000 |
| Interquartile range (IQR) | 11778500 |
Descriptive statistics
| Standard deviation | 9976524.9 |
|---|---|
| Coefficient of variation (CV) | 0.65991604 |
| Kurtosis | -0.22931809 |
| Mean | 15117870 |
| Median Absolute Deviation (MAD) | 5899000 |
| Skewness | 0.6280489 |
| Sum | 5.1249579 × 109 |
| Variance | 9.953105 × 1013 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 8889000 | 2 | 0.6% |
| 35360000 | 2 | 0.6% |
| 2576000 | 2 | 0.6% |
| 2519000 | 2 | 0.6% |
| 8844000 | 2 | 0.6% |
| 19118000 | 1 | 0.3% |
| 2090000 | 1 | 0.3% |
| 10956070 | 1 | 0.3% |
| 2066000 | 1 | 0.3% |
| 21708000 | 1 | 0.3% |
| Other values (324) | 324 | |
| (Missing) | 3 | 0.9% |
| Value | Count | Frequency (%) |
| 398000 | 1 | |
| 445000 | 1 | |
| 498000 | 1 | |
| 516000 | 1 | |
| 663000 | 1 | |
| 710000 | 1 | |
| 903000 | 1 | |
| 1086000 | 1 | |
| 1161000 | 1 | |
| 1333000 | 1 |
| Value | Count | Frequency (%) |
| 39719000 | 1 | |
| 38994000 | 1 | |
| 38705000 | 1 | |
| 38679000 | 1 | |
| 38308000 | 1 | |
| 38229000 | 1 | |
| 38145000 | 1 | |
| 37779000 | 1 | |
| 37775000 | 1 | |
| 37571000 | 1 |
PTL_MDU (Business Days Mean)
Real number (ℝ)
| Distinct | 293 |
|---|---|
| Distinct (%) | 86.4% |
| Missing | 3 |
| Missing (%) | 0.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 606098.53 |
| Minimum | 22000 |
|---|---|
| Maximum | 1538000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.3 KiB |
Quantile statistics
| Minimum | 22000 |
|---|---|
| 5-th percentile | 64900 |
| Q1 | 331500 |
| median | 553000 |
| Q3 | 809500 |
| 95-th percentile | 1447700 |
| Maximum | 1538000 |
| Range | 1516000 |
| Interquartile range (IQR) | 478000 |
Descriptive statistics
| Standard deviation | 398042.32 |
|---|---|
| Coefficient of variation (CV) | 0.65672873 |
| Kurtosis | -0.23864419 |
| Mean | 606098.53 |
| Median Absolute Deviation (MAD) | 244000 |
| Skewness | 0.62441348 |
| Sum | 2.054674 × 108 |
| Variance | 1.5843769 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 649000 | 3 | 0.9% |
| 818000 | 3 | 0.9% |
| 64000 | 3 | 0.9% |
| 548000 | 3 | 0.9% |
| 1477000 | 3 | 0.9% |
| 68000 | 2 | 0.6% |
| 469000 | 2 | 0.6% |
| 99000 | 2 | 0.6% |
| 648000 | 2 | 0.6% |
| 535000 | 2 | 0.6% |
| Other values (283) | 314 | |
| (Missing) | 3 | 0.9% |
| Value | Count | Frequency (%) |
| 22000 | 2 | |
| 23000 | 2 | |
| 27000 | 1 | |
| 32000 | 1 | |
| 37000 | 1 | |
| 44000 | 1 | |
| 48000 | 1 | |
| 52000 | 1 | |
| 57000 | 1 | |
| 58000 | 1 |
| Value | Count | Frequency (%) |
| 1538000 | 1 | 0.3% |
| 1525000 | 1 | 0.3% |
| 1519000 | 1 | 0.3% |
| 1497000 | 1 | 0.3% |
| 1493000 | 1 | 0.3% |
| 1481000 | 1 | 0.3% |
| 1477000 | 3 | |
| 1470000 | 1 | 0.3% |
| 1466000 | 1 | 0.3% |
| 1463000 | 1 | 0.3% |
PTL_MSD (Saturdays Mean)
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 283 |
|---|---|
| Distinct (%) | 84.0% |
| Missing | 5 |
| Missing (%) | 1.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 357180.39 |
| Minimum | 3000 |
|---|---|
| Maximum | 933000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.3 KiB |
Quantile statistics
| Minimum | 3000 |
|---|---|
| 5-th percentile | 32800 |
| Q1 | 196000 |
| median | 309000 |
| Q3 | 482000 |
| 95-th percentile | 856000 |
| Maximum | 933000 |
| Range | 930000 |
| Interquartile range (IQR) | 286000 |
Descriptive statistics
| Standard deviation | 246731.65 |
|---|---|
| Coefficient of variation (CV) | 0.69077604 |
| Kurtosis | -0.38539999 |
| Mean | 357180.39 |
| Median Absolute Deviation (MAD) | 139000 |
| Skewness | 0.69172277 |
| Sum | 1.2036979 × 108 |
| Variance | 6.0876508 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 217000 | 3 | 0.9% |
| 222000 | 3 | 0.9% |
| 42000 | 3 | 0.9% |
| 196000 | 3 | 0.9% |
| 299000 | 3 | 0.9% |
| 208000 | 3 | 0.9% |
| 39000 | 3 | 0.9% |
| 31000 | 2 | 0.6% |
| 623000 | 2 | 0.6% |
| 231000 | 2 | 0.6% |
| Other values (273) | 310 | |
| (Missing) | 5 | 1.5% |
| Value | Count | Frequency (%) |
| 3000 | 1 | |
| 6000 | 1 | |
| 14000 | 1 | |
| 15000 | 1 | |
| 17000 | 1 | |
| 21000 | 1 | |
| 23000 | 1 | |
| 25000 | 2 | |
| 26000 | 1 | |
| 27000 | 1 |
| Value | Count | Frequency (%) |
| 933000 | 1 | |
| 924000 | 1 | |
| 914000 | 1 | |
| 909000 | 1 | |
| 893000 | 1 | |
| 892000 | 1 | |
| 890000 | 2 | |
| 887000 | 1 | |
| 884000 | 1 | |
| 873000 | 1 |
PTL_MDO (Sundays Mean)
Real number (ℝ)
| Distinct | 240 |
|---|---|
| Distinct (%) | 70.8% |
| Missing | 3 |
| Missing (%) | 0.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 203710.21 |
| Minimum | 2000 |
|---|---|
| Maximum | 573000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.3 KiB |
Quantile statistics
| Minimum | 2000 |
|---|---|
| 5-th percentile | 18000 |
| Q1 | 104500 |
| median | 179000 |
| Q3 | 264500 |
| 95-th percentile | 495000 |
| Maximum | 573000 |
| Range | 571000 |
| Interquartile range (IQR) | 160000 |
Descriptive statistics
| Standard deviation | 143959.33 |
|---|---|
| Coefficient of variation (CV) | 0.7066869 |
| Kurtosis | -0.27455524 |
| Mean | 203710.21 |
| Median Absolute Deviation (MAD) | 78000 |
| Skewness | 0.72028294 |
| Sum | 69057760 |
| Variance | 2.072429 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 21000 | 5 | 1.5% |
| 20000 | 5 | 1.5% |
| 34000 | 4 | 1.2% |
| 114000 | 4 | 1.2% |
| 23000 | 3 | 0.9% |
| 163000 | 3 | 0.9% |
| 233000 | 3 | 0.9% |
| 9000 | 3 | 0.9% |
| 18000 | 3 | 0.9% |
| 24000 | 3 | 0.9% |
| Other values (230) | 303 |
| Value | Count | Frequency (%) |
| 2000 | 2 | 0.6% |
| 4000 | 2 | 0.6% |
| 9000 | 3 | |
| 11000 | 1 | 0.3% |
| 13000 | 1 | 0.3% |
| 14000 | 2 | 0.6% |
| 16000 | 2 | 0.6% |
| 17000 | 2 | 0.6% |
| 18000 | 3 | |
| 20000 | 5 |
| Value | Count | Frequency (%) |
| 573000 | 1 | |
| 557000 | 1 | |
| 556000 | 1 | |
| 543000 | 1 | |
| 538000 | 1 | |
| 537000 | 1 | |
| 528000 | 1 | |
| 526000 | 1 | |
| 523000 | 1 | |
| 520000 | 1 |
PTL_MAX (Daily Max)
Real number (ℝ)
| Distinct | 301 |
|---|---|
| Distinct (%) | 88.8% |
| Missing | 3 |
| Missing (%) | 0.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 650882.51 |
| Minimum | 23000 |
|---|---|
| Maximum | 1611000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.3 KiB |
Quantile statistics
| Minimum | 23000 |
|---|---|
| 5-th percentile | 69900 |
| Q1 | 359500 |
| median | 607000 |
| Q3 | 851000 |
| 95-th percentile | 1508300 |
| Maximum | 1611000 |
| Range | 1588000 |
| Interquartile range (IQR) | 491500 |
Descriptive statistics
| Standard deviation | 421148.31 |
|---|---|
| Coefficient of variation (CV) | 0.64704199 |
| Kurtosis | -0.34340512 |
| Mean | 650882.51 |
| Median Absolute Deviation (MAD) | 246000 |
| Skewness | 0.56670231 |
| Sum | 2.2064917 × 108 |
| Variance | 1.773659 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 373000 | 3 | 0.9% |
| 385000 | 3 | 0.9% |
| 1483000 | 2 | 0.6% |
| 76000 | 2 | 0.6% |
| 853000 | 2 | 0.6% |
| 1513000 | 2 | 0.6% |
| 591000 | 2 | 0.6% |
| 114000 | 2 | 0.6% |
| 801000 | 2 | 0.6% |
| 1048000 | 2 | 0.6% |
| Other values (291) | 317 | |
| (Missing) | 3 | 0.9% |
| Value | Count | Frequency (%) |
| 23000 | 2 | |
| 25000 | 2 | |
| 37000 | 1 | |
| 39000 | 1 | |
| 46000 | 1 | |
| 49000 | 1 | |
| 54000 | 1 | |
| 57000 | 1 | |
| 63000 | 2 | |
| 66000 | 2 |
| Value | Count | Frequency (%) |
| 1611000 | 1 | |
| 1585000 | 1 | |
| 1571000 | 1 | |
| 1558000 | 1 | |
| 1552000 | 1 | |
| 1550000 | 1 | |
| 1548000 | 1 | |
| 1544000 | 2 | |
| 1539000 | 1 | |
| 1532000 | 1 |
stations
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 6 |
|---|---|
| Distinct (%) | 3.6% |
| Missing | 174 |
| Missing (%) | 50.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.571429 |
| Minimum | 10 |
|---|---|
| Maximum | 23 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.3 KiB |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 10 |
| Q1 | 11 |
| median | 15.5 |
| Q3 | 18 |
| 95-th percentile | 23 |
| Maximum | 23 |
| Range | 13 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 4.3562488 |
|---|---|
| Coefficient of variation (CV) | 0.2797591 |
| Kurtosis | -0.99644197 |
| Mean | 15.571429 |
| Median Absolute Deviation (MAD) | 3.5 |
| Skewness | 0.3858772 |
| Sum | 2616 |
| Variance | 18.976903 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 11 | 40 | 11.7% |
| 18 | 28 | 8.2% |
| 14 | 28 | 8.2% |
| 23 | 28 | 8.2% |
| 17 | 28 | 8.2% |
| 10 | 16 | 4.7% |
| (Missing) | 174 |
| Value | Count | Frequency (%) |
| 10 | 16 | 4.7% |
| 11 | 40 | |
| 14 | 28 | |
| 17 | 28 | |
| 18 | 28 | |
| 23 | 28 |
| Value | Count | Frequency (%) |
| 23 | 28 | |
| 18 | 28 | |
| 17 | 28 | |
| 14 | 28 | |
| 11 | 40 | |
| 10 | 16 | 4.7% |
total_dpea
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 156 |
|---|---|
| Distinct (%) | 92.9% |
| Missing | 174 |
| Missing (%) | 50.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 539427.8 |
| Minimum | 56000 |
|---|---|
| Maximum | 1092000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.3 KiB |
Quantile statistics
| Minimum | 56000 |
|---|---|
| 5-th percentile | 81750 |
| Q1 | 350750 |
| median | 515470 |
| Q3 | 727000 |
| 95-th percentile | 1036650 |
| Maximum | 1092000 |
| Range | 1036000 |
| Interquartile range (IQR) | 376250 |
Descriptive statistics
| Standard deviation | 295292.95 |
|---|---|
| Coefficient of variation (CV) | 0.54741887 |
| Kurtosis | -0.82293366 |
| Mean | 539427.8 |
| Median Absolute Deviation (MAD) | 177000 |
| Skewness | 0.14722387 |
| Sum | 90623870 |
| Variance | 8.7197929 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1010000 | 2 | 0.6% |
| 64000 | 2 | 0.6% |
| 99000 | 2 | 0.6% |
| 617000 | 2 | 0.6% |
| 549000 | 2 | 0.6% |
| 288000 | 2 | 0.6% |
| 298000 | 2 | 0.6% |
| 108000 | 2 | 0.6% |
| 112000 | 2 | 0.6% |
| 1064000 | 2 | 0.6% |
| Other values (146) | 148 | |
| (Missing) | 174 |
| Value | Count | Frequency (%) |
| 56000 | 1 | |
| 58000 | 1 | |
| 64000 | 2 | |
| 65000 | 1 | |
| 68000 | 1 | |
| 74000 | 1 | |
| 78000 | 1 | |
| 80000 | 1 | |
| 85000 | 1 | |
| 87000 | 1 |
| Value | Count | Frequency (%) |
| 1092000 | 1 | |
| 1086000 | 1 | |
| 1066000 | 1 | |
| 1064000 | 2 | |
| 1060000 | 1 | |
| 1058000 | 1 | |
| 1052000 | 1 | |
| 1037000 | 1 | |
| 1036000 | 1 | |
| 1026000 | 1 |
interval
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 30 |
|---|---|
| Distinct (%) | 26.8% |
| Missing | 230 |
| Missing (%) | 67.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 147.125 |
| Minimum | 119 |
|---|---|
| Maximum | 235 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.3 KiB |
Quantile statistics
| Minimum | 119 |
|---|---|
| 5-th percentile | 119 |
| Q1 | 119 |
| median | 131.5 |
| Q3 | 176.5 |
| 95-th percentile | 210 |
| Maximum | 235 |
| Range | 116 |
| Interquartile range (IQR) | 57.5 |
Descriptive statistics
| Standard deviation | 34.012484 |
|---|---|
| Coefficient of variation (CV) | 0.23118086 |
| Kurtosis | -0.58763508 |
| Mean | 147.125 |
| Median Absolute Deviation (MAD) | 12.5 |
| Skewness | 0.92809199 |
| Sum | 16478 |
| Variance | 1156.8491 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=30)
| Value | Count | Frequency (%) |
| 119 | 31 | 9.1% |
| 120 | 8 | 2.3% |
| 196 | 8 | 2.3% |
| 133 | 8 | 2.3% |
| 174 | 7 | 2.0% |
| 184 | 7 | 2.0% |
| 123 | 6 | 1.8% |
| 210 | 4 | 1.2% |
| 134 | 3 | 0.9% |
| 136 | 3 | 0.9% |
| Other values (20) | 27 | 7.9% |
| (Missing) | 230 |
| Value | Count | Frequency (%) |
| 119 | 31 | |
| 120 | 8 | 2.3% |
| 121 | 1 | 0.3% |
| 123 | 6 | 1.8% |
| 124 | 2 | 0.6% |
| 125 | 2 | 0.6% |
| 126 | 1 | 0.3% |
| 127 | 2 | 0.6% |
| 128 | 2 | 0.6% |
| 130 | 1 | 0.3% |
| Value | Count | Frequency (%) |
| 235 | 2 | 0.6% |
| 217 | 2 | 0.6% |
| 210 | 4 | |
| 206 | 1 | 0.3% |
| 202 | 1 | 0.3% |
| 196 | 8 | |
| 192 | 1 | 0.3% |
| 188 | 2 | 0.6% |
| 184 | 7 | |
| 174 | 7 |
PEL_total
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 223 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 119 |
| Missing (%) | 34.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 33296767 |
| Minimum | 219000 |
|---|---|
| Maximum | 9.7 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.3 KiB |
Quantile statistics
| Minimum | 219000 |
|---|---|
| 5-th percentile | 858600 |
| Q1 | 5072500 |
| median | 12946000 |
| Q3 | 20123000 |
| 95-th percentile | 30184500 |
| Maximum | 9.7 × 108 |
| Range | 9.69781 × 108 |
| Interquartile range (IQR) | 15050500 |
Descriptive statistics
| Standard deviation | 1.3470726 × 108 |
|---|---|
| Coefficient of variation (CV) | 4.045656 |
| Kurtosis | 40.74117 |
| Mean | 33296767 |
| Median Absolute Deviation (MAD) | 7562000 |
| Skewness | 6.4820801 |
| Sum | 7.425179 × 109 |
| Variance | 1.8146047 × 1016 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 32413000 | 1 | 0.3% |
| 16326000 | 1 | 0.3% |
| 7899000 | 1 | 0.3% |
| 14620000 | 1 | 0.3% |
| 17307000 | 1 | 0.3% |
| 8167000 | 1 | 0.3% |
| 1214000 | 1 | 0.3% |
| 8506000 | 1 | 0.3% |
| 15384000 | 1 | 0.3% |
| 18109000 | 1 | 0.3% |
| Other values (213) | 213 | |
| (Missing) | 119 |
| Value | Count | Frequency (%) |
| 219000 | 1 | |
| 243000 | 1 | |
| 325000 | 1 | |
| 397000 | 1 | |
| 405000 | 1 | |
| 504000 | 1 | |
| 545000 | 1 | |
| 606000 | 1 | |
| 709000 | 1 | |
| 767000 | 1 |
| Value | Count | Frequency (%) |
| 970000000 | 1 | |
| 966000000 | 1 | |
| 932000000 | 1 | |
| 887000000 | 1 | |
| 831000000 | 1 | |
| 32413000 | 1 | |
| 32289000 | 1 | |
| 31728000 | 1 | |
| 31717000 | 1 | |
| 31037000 | 1 |
PEL_business_day_mean
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 196 |
|---|---|
| Distinct (%) | 87.9% |
| Missing | 119 |
| Missing (%) | 34.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 509852.02 |
| Minimum | 13000 |
|---|---|
| Maximum | 1241000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.3 KiB |
Quantile statistics
| Minimum | 13000 |
|---|---|
| 5-th percentile | 36000 |
| Q1 | 132500 |
| median | 509000 |
| Q3 | 752000 |
| 95-th percentile | 1165400 |
| Maximum | 1241000 |
| Range | 1228000 |
| Interquartile range (IQR) | 619500 |
Descriptive statistics
| Standard deviation | 365266.96 |
|---|---|
| Coefficient of variation (CV) | 0.71641761 |
| Kurtosis | -0.94982454 |
| Mean | 509852.02 |
| Median Absolute Deviation (MAD) | 284000 |
| Skewness | 0.28746419 |
| Sum | 1.13697 × 108 |
| Variance | 1.3341996 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 40000 | 3 | 0.9% |
| 64000 | 3 | 0.9% |
| 62000 | 3 | 0.9% |
| 493000 | 2 | 0.6% |
| 647000 | 2 | 0.6% |
| 69000 | 2 | 0.6% |
| 36000 | 2 | 0.6% |
| 614000 | 2 | 0.6% |
| 46000 | 2 | 0.6% |
| 51000 | 2 | 0.6% |
| Other values (186) | 200 | |
| (Missing) | 119 |
| Value | Count | Frequency (%) |
| 13000 | 2 | |
| 16000 | 1 | |
| 18000 | 1 | |
| 20000 | 1 | |
| 27000 | 2 | |
| 31000 | 1 | |
| 34000 | 1 | |
| 35000 | 2 | |
| 36000 | 2 | |
| 38000 | 1 |
| Value | Count | Frequency (%) |
| 1241000 | 1 | |
| 1227000 | 1 | |
| 1223000 | 1 | |
| 1222000 | 1 | |
| 1221000 | 1 | |
| 1216000 | 1 | |
| 1212000 | 2 | |
| 1211000 | 1 | |
| 1187000 | 1 | |
| 1177000 | 1 |
PEL_saturday_mean
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 183 |
|---|---|
| Distinct (%) | 82.1% |
| Missing | 119 |
| Missing (%) | 34.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 302529.15 |
| Minimum | 1000 |
|---|---|
| Maximum | 761000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.3 KiB |
Quantile statistics
| Minimum | 1000 |
|---|---|
| 5-th percentile | 15200 |
| Q1 | 99500 |
| median | 263000 |
| Q3 | 487500 |
| 95-th percentile | 697500 |
| Maximum | 761000 |
| Range | 760000 |
| Interquartile range (IQR) | 388000 |
Descriptive statistics
| Standard deviation | 224005.71 |
|---|---|
| Coefficient of variation (CV) | 0.74044339 |
| Kurtosis | -1.0965712 |
| Mean | 302529.15 |
| Median Absolute Deviation (MAD) | 212000 |
| Skewness | 0.29633313 |
| Sum | 67464000 |
| Variance | 5.0178557 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 26000 | 4 | 1.2% |
| 23000 | 3 | 0.9% |
| 19000 | 3 | 0.9% |
| 34000 | 3 | 0.9% |
| 36000 | 3 | 0.9% |
| 724000 | 2 | 0.6% |
| 729000 | 2 | 0.6% |
| 231000 | 2 | 0.6% |
| 18000 | 2 | 0.6% |
| 511000 | 2 | 0.6% |
| Other values (173) | 197 | |
| (Missing) | 119 |
| Value | Count | Frequency (%) |
| 1000 | 1 | |
| 3000 | 1 | |
| 7000 | 2 | |
| 8000 | 1 | |
| 10000 | 1 | |
| 12000 | 2 | |
| 13000 | 1 | |
| 14000 | 1 | |
| 15000 | 2 | |
| 17000 | 2 |
| Value | Count | Frequency (%) |
| 761000 | 1 | |
| 753000 | 1 | |
| 729000 | 2 | |
| 724000 | 2 | |
| 722000 | 1 | |
| 712000 | 1 | |
| 704000 | 1 | |
| 700000 | 1 | |
| 699000 | 1 | |
| 698000 | 1 |
PEL_sunday_mean
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 157 |
|---|---|
| Distinct (%) | 70.4% |
| Missing | 119 |
| Missing (%) | 34.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 173547.09 |
| Minimum | 1000 |
|---|---|
| Maximum | 466000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.3 KiB |
Quantile statistics
| Minimum | 1000 |
|---|---|
| 5-th percentile | 9100 |
| Q1 | 54000 |
| median | 161000 |
| Q3 | 276500 |
| 95-th percentile | 402000 |
| Maximum | 466000 |
| Range | 465000 |
| Interquartile range (IQR) | 222500 |
Descriptive statistics
| Standard deviation | 128735.52 |
|---|---|
| Coefficient of variation (CV) | 0.74179017 |
| Kurtosis | -0.92373264 |
| Mean | 173547.09 |
| Median Absolute Deviation (MAD) | 108000 |
| Skewness | 0.34669862 |
| Sum | 38701000 |
| Variance | 1.6572834 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10000 | 7 | 2.0% |
| 14000 | 5 | 1.5% |
| 13000 | 4 | 1.2% |
| 20000 | 4 | 1.2% |
| 12000 | 4 | 1.2% |
| 153000 | 3 | 0.9% |
| 18000 | 3 | 0.9% |
| 235000 | 3 | 0.9% |
| 8000 | 3 | 0.9% |
| 321000 | 3 | 0.9% |
| Other values (147) | 184 | |
| (Missing) | 119 |
| Value | Count | Frequency (%) |
| 1000 | 1 | 0.3% |
| 2000 | 1 | 0.3% |
| 4000 | 1 | 0.3% |
| 5000 | 2 | 0.6% |
| 6000 | 1 | 0.3% |
| 7000 | 1 | 0.3% |
| 8000 | 3 | |
| 9000 | 2 | 0.6% |
| 10000 | 7 | |
| 11000 | 3 |
| Value | Count | Frequency (%) |
| 466000 | 1 | |
| 461000 | 1 | |
| 451000 | 1 | |
| 431000 | 1 | |
| 429000 | 1 | |
| 425000 | 2 | |
| 418000 | 1 | |
| 412000 | 1 | |
| 410000 | 1 | |
| 409000 | 1 |
PEL_max
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 186 |
|---|---|
| Distinct (%) | 83.4% |
| Missing | 119 |
| Missing (%) | 34.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 555816.14 |
| Minimum | 13000 |
|---|---|
| Maximum | 1307000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.3 KiB |
Quantile statistics
| Minimum | 13000 |
|---|---|
| 5-th percentile | 40100 |
| Q1 | 191500 |
| median | 565000 |
| Q3 | 828000 |
| 95-th percentile | 1233900 |
| Maximum | 1307000 |
| Range | 1294000 |
| Interquartile range (IQR) | 636500 |
Descriptive statistics
| Standard deviation | 390923.78 |
|---|---|
| Coefficient of variation (CV) | 0.7033329 |
| Kurtosis | -1.0392436 |
| Mean | 555816.14 |
| Median Absolute Deviation (MAD) | 310000 |
| Skewness | 0.22193679 |
| Sum | 1.23947 × 108 |
| Variance | 1.528214 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 43000 | 4 | 1.2% |
| 55000 | 4 | 1.2% |
| 74000 | 4 | 1.2% |
| 64000 | 3 | 0.9% |
| 286000 | 3 | 0.9% |
| 46000 | 3 | 0.9% |
| 1113000 | 2 | 0.6% |
| 888000 | 2 | 0.6% |
| 37000 | 2 | 0.6% |
| 66000 | 2 | 0.6% |
| Other values (176) | 194 | |
| (Missing) | 119 |
| Value | Count | Frequency (%) |
| 13000 | 1 | |
| 14000 | 1 | |
| 21000 | 1 | |
| 23000 | 1 | |
| 25000 | 1 | |
| 29000 | 1 | |
| 30000 | 1 | |
| 34000 | 1 | |
| 37000 | 2 | |
| 39000 | 1 |
| Value | Count | Frequency (%) |
| 1307000 | 1 | |
| 1298000 | 1 | |
| 1293000 | 1 | |
| 1267000 | 1 | |
| 1261000 | 2 | |
| 1257000 | 1 | |
| 1256000 | 1 | |
| 1254000 | 1 | |
| 1248000 | 1 | |
| 1241000 | 1 |
| PTL_total | PTL_MDU (Business Days Mean) | PTL_MSD (Saturdays Mean) | PTL_MDO (Sundays Mean) | PTL_MAX (Daily Max) | stations | total_dpea | interval | PEL_total | PEL_business_day_mean | PEL_saturday_mean | PEL_sunday_mean | PEL_max | line | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PTL_total | 1.000 | 0.996 | 0.984 | 0.981 | 0.989 | 0.728 | 0.994 | -0.926 | 0.859 | 0.951 | 0.981 | 0.981 | 0.970 | 0.532 |
| PTL_MDU (Business Days Mean) | 0.996 | 1.000 | 0.981 | 0.980 | 0.992 | 0.730 | 1.000 | -0.931 | 0.857 | 0.955 | 0.977 | 0.981 | 0.973 | 0.534 |
| PTL_MSD (Saturdays Mean) | 0.984 | 0.981 | 1.000 | 0.986 | 0.971 | 0.719 | 0.982 | -0.920 | 0.854 | 0.939 | 0.996 | 0.986 | 0.962 | 0.575 |
| PTL_MDO (Sundays Mean) | 0.981 | 0.980 | 0.986 | 1.000 | 0.973 | 0.695 | 0.980 | -0.904 | 0.857 | 0.944 | 0.991 | 0.995 | 0.968 | 0.571 |
| PTL_MAX (Daily Max) | 0.989 | 0.992 | 0.971 | 0.973 | 1.000 | 0.736 | 0.992 | -0.922 | 0.848 | 0.950 | 0.971 | 0.978 | 0.980 | 0.551 |
| stations | 0.728 | 0.730 | 0.719 | 0.695 | 0.736 | 1.000 | 0.731 | -0.850 | 0.600 | 0.807 | 0.811 | 0.798 | 0.812 | 0.997 |
| total_dpea | 0.994 | 1.000 | 0.982 | 0.980 | 0.992 | 0.731 | 1.000 | -0.931 | 0.726 | 0.989 | 0.967 | 0.965 | 0.978 | 0.588 |
| interval | -0.926 | -0.931 | -0.920 | -0.904 | -0.922 | -0.850 | -0.931 | 1.000 | -0.668 | -0.931 | -0.918 | -0.906 | -0.923 | 0.719 |
| PEL_total | 0.859 | 0.857 | 0.854 | 0.857 | 0.848 | 0.600 | 0.726 | -0.668 | 1.000 | 0.819 | 0.860 | 0.863 | 0.836 | 0.156 |
| PEL_business_day_mean | 0.951 | 0.955 | 0.939 | 0.944 | 0.950 | 0.807 | 0.989 | -0.931 | 0.819 | 1.000 | 0.944 | 0.948 | 0.967 | 0.654 |
| PEL_saturday_mean | 0.981 | 0.977 | 0.996 | 0.991 | 0.971 | 0.811 | 0.967 | -0.918 | 0.860 | 0.944 | 1.000 | 0.992 | 0.965 | 0.743 |
| PEL_sunday_mean | 0.981 | 0.981 | 0.986 | 0.995 | 0.978 | 0.798 | 0.965 | -0.906 | 0.863 | 0.948 | 0.992 | 1.000 | 0.971 | 0.706 |
| PEL_max | 0.970 | 0.973 | 0.962 | 0.968 | 0.980 | 0.812 | 0.978 | -0.923 | 0.836 | 0.967 | 0.965 | 0.971 | 1.000 | 0.693 |
| line | 0.532 | 0.534 | 0.575 | 0.571 | 0.551 | 0.997 | 0.588 | 0.719 | 0.156 | 0.654 | 0.743 | 0.706 | 0.693 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| date | line | PTL_total | PTL_MDU (Business Days Mean) | PTL_MSD (Saturdays Mean) | PTL_MDO (Sundays Mean) | PTL_MAX (Daily Max) | stations | total_dpea | interval | PEL_total | PEL_business_day_mean | PEL_saturday_mean | PEL_sunday_mean | PEL_max | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2018-08-01 | 3 | 38679000.0 | 1440000.0 | 884000.0 | 504000.0 | 1483000.0 | NaN | NaN | NaN | 32413000.0 | 1211000.0 | 724000.0 | 418000.0 | 1248000.0 |
| 1 | 2018-08-01 | 1 | 37775000.0 | 1420000.0 | 832000.0 | 446000.0 | 1466000.0 | NaN | NaN | NaN | 27733000.0 | 1048000.0 | 598000.0 | 307000.0 | 1086000.0 |
| 2 | 2018-08-01 | 15 | 516000.0 | 22000.0 | NaN | 2000.0 | 23000.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 3 | 2018-08-01 | 2 | 18164000.0 | 701000.0 | 318000.0 | 194000.0 | 723000.0 | NaN | NaN | NaN | 14509000.0 | 560000.0 | 250000.0 | 155000.0 | 581000.0 |
| 4 | 2018-08-01 | 5 | 7220000.0 | 309000.0 | 176000.0 | 85000.0 | 322000.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 5 | 2018-08-01 | 4 | 20844000.0 | 797000.0 | 397000.0 | 229000.0 | 827000.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 6 | 2018-09-01 | 4 | 18080000.0 | 800000.0 | 411000.0 | 111000.0 | 841000.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 7 | 2018-09-01 | 5 | 7632000.0 | 323000.0 | 182000.0 | 93000.0 | 345000.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 8 | 2018-09-01 | 15 | 445000.0 | 23000.0 | 3000.0 | 2000.0 | 23000.0 | NaN | NaN | NaN | 243000.0 | 13000.0 | 1000.0 | 1000.0 | 13000.0 |
| 9 | 2018-09-01 | 2 | 16246000.0 | 705000.0 | 321000.0 | 202000.0 | 733000.0 | NaN | NaN | NaN | 12946000.0 | 562000.0 | 254000.0 | 162000.0 | 582000.0 |
| date | line | PTL_total | PTL_MDU (Business Days Mean) | PTL_MSD (Saturdays Mean) | PTL_MDO (Sundays Mean) | PTL_MAX (Daily Max) | stations | total_dpea | interval | PEL_total | PEL_business_day_mean | PEL_saturday_mean | PEL_sunday_mean | PEL_max | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 332 | 2023-03-01 | 5 | 13455770.0 | 503110.0 | 305230.0 | 165840.0 | 535970.0 | 17.0 | 503120.0 | NaN | NaN | NaN | NaN | NaN | NaN |
| 333 | 2023-03-01 | 4 | 17370640.0 | 649070.0 | 389010.0 | 221480.0 | 711990.0 | 11.0 | 649070.0 | NaN | NaN | NaN | NaN | NaN | NaN |
| 334 | 2023-03-01 | 15 | 2876000.0 | 120000.0 | 65000.0 | 35000.0 | 128000.0 | 11.0 | 120000.0 | 184.0 | 1692000.0 | 72000.0 | 40000.0 | 21000.0 | 74000.0 |
| 335 | 2023-03-01 | 3 | 27409000.0 | 1067000.0 | 676000.0 | 387000.0 | 1096000.0 | 18.0 | 1066000.0 | 119.0 | 22571000.0 | 888000.0 | 539000.0 | 311000.0 | 914000.0 |
| 336 | 2023-04-01 | 3 | 25011000.0 | 1066000.0 | 627000.0 | 371000.0 | 1157000.0 | 18.0 | 1064000.0 | 119.0 | 20602000.0 | 886000.0 | 501000.0 | 296000.0 | 973000.0 |
| 337 | 2023-04-01 | 2 | 14544000.0 | 649000.0 | 299000.0 | 189000.0 | 671000.0 | 14.0 | 651000.0 | 136.0 | 10961000.0 | 492000.0 | 219000.0 | 140000.0 | 512000.0 |
| 338 | 2023-04-01 | 4 | 15070570.0 | 661450.0 | 338300.0 | 201580.0 | 701710.0 | 11.0 | 661470.0 | NaN | NaN | NaN | NaN | NaN | NaN |
| 339 | 2023-04-01 | 5 | 11792220.0 | 510810.0 | 282420.0 | 160710.0 | 527250.0 | 17.0 | 510800.0 | NaN | NaN | NaN | NaN | NaN | NaN |
| 340 | 2023-04-01 | 1 | 25545000.0 | 1091000.0 | 639000.0 | 375000.0 | 1130000.0 | 23.0 | 1092000.0 | 119.0 | 18701000.0 | 808000.0 | 453000.0 | 262000.0 | 830000.0 |
| 341 | 2023-04-01 | 15 | 2827000.0 | 124000.0 | 63000.0 | 37000.0 | 127000.0 | 11.0 | 123000.0 | 184.0 | 1653000.0 | 72000.0 | 37000.0 | 22000.0 | 74000.0 |